﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_CHANGE_REQUEST_RESULTS_UP')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_CHANGE_REQUEST_RESULTS_UP
	END

GO

CREATE Procedure dbo.PRC_TB_CHANGE_REQUEST_RESULTS_UP
	(
		@TCR_ID int,
		@TCR_DESCRIPTION varchar(80)
	)

AS

update TB_CHANGE_REQUEST_RESULTS
set TCR_DESCRIPTION = @TCR_DESCRIPTION
where TCR_ID = @TCR_ID



GO

GRANT EXEC ON dbo.PRC_TB_CHANGE_REQUEST_RESULTS_UP TO PUBLIC

GO

